SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 50641: Errors occur when you execute a job in which the parameter values contain text values that end in a percent sign (%)

DetailsAboutRate It

If Job or Transformation parameters contain text values that end in a percent sign (%), the percent sign is not properly masked in the code that is generated. This can result in errors when you execute a job.

If the parameter values for a Loop transformation contain the text values that end in a percent sign, you might receive the following error message:

ERROR: Expected close parenthesis after macro function invocation not found.

To work around the errors that are received in a Loop transformation, modify the code that is generated by SAS® Data Integration Studio.

  1. Open the job in the job editor window. Right-click the Loop transformation and select Properties.
  2. Click the Code tab. Change the code generation mode to user written body.
  3. Locate the following line in the code:
    value='%str('||trim(value)||')';
  4. Change the %STR function to %NRSTR:
    value='%nrstr('||trim(value)||')';
  5. Save your job.



      Operating System and Release Information

      Product FamilyProductSystemProduct ReleaseSAS Release
      ReportedFixed*ReportedFixed*
      SAS SystemSAS Data Integration StudioWindows Vista for x644.21_M19.2 TS2M3
      Windows Vista4.21_M19.2 TS2M3
      Windows 7 Ultimate x644.21_M14.89.2 TS2M39.4 TS1M1
      Windows 7 Ultimate 32 bit4.21_M14.89.2 TS2M39.4 TS1M1
      Windows 7 Professional x644.21_M14.89.2 TS2M39.4 TS1M1
      Windows 7 Professional 32 bit4.21_M14.89.2 TS2M39.4 TS1M1
      Windows 7 Home Premium x644.21_M14.89.2 TS2M39.4 TS1M1
      Windows 7 Home Premium 32 bit4.21_M14.89.2 TS2M39.4 TS1M1
      Windows 7 Enterprise x644.21_M14.89.2 TS2M39.4 TS1M1
      Windows 7 Enterprise 32 bit4.21_M14.89.2 TS2M39.4 TS1M1
      Microsoft Windows XP Professional4.21_M19.2 TS2M3
      Microsoft Windows Server 2008 for x644.21_M14.89.2 TS2M39.4 TS1M1
      Microsoft® Windows® for x644.21_M14.89.2 TS2M39.4 TS1M1
      Microsoft Windows Server 2003 Datacenter Edition4.21_M19.2 TS2M3
      Microsoft Windows Server 2003 Enterprise Edition4.21_M19.2 TS2M3
      Microsoft Windows Server 2003 Standard Edition4.21_M19.2 TS2M3
      Microsoft Windows Server 2003 for x644.21_M19.2 TS2M3
      Microsoft Windows Server 20084.21_M14.89.2 TS2M39.4 TS1M1
      Microsoft Windows Server 2008 R24.21_M14.89.2 TS2M39.4 TS1M1
      * For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.